Problem Solving Techniques with SQL

Solving technical problems involves the use of good techniques. Data processing problems frequently involve a great deal of data manipulation and computing resources. When confronted with problems of this nature, you could approach them using conventional DATA, and/or PROC step methods, or you could use the strengths of the SQL procedure to manipulate and process this data. Attendees will learn how SQL can be used to solve traditional, as well as not so traditional, problems including retrieving and subsetting data, using summary functions to compute statistical information, accessing the read-only dictionary tables to monitor a SAS session, constructing and using views to control what and how data is accessed, performing inner and outer joins for data discovery, and constructing efficient queries that will not only process quickly, but provide ease of maintenance.